--Supplier--------------------------------

insert into SupplierC2207
values('S01','B.G.Perera','no 23,1st lane,Piliyandala');

insert into SupplierC2207
values('S02','Ravin Gunasekara','No 100,samagi mv,Kelaniya');

insert into SupplierC2207
values('S03','S.E.Jayarathane','Hilton road,Colombo 7');

insert into SupplierC2207
values('S04','Akila Peramuna','No 21,2nd Lane,Moratuwa');

insert into SupplierC2207
values('S05','H.B.Kirinda','no 56,Temple road,Panadura');

insert into SupplierC2207
values('S06','S.S.Meegoda','No 50,Main street,Mount Lavinia');

insert into SupplierC2207
values('S07','D.W.Perera','No 25/1,Senanayaka Road,Dehiwala');

insert into SupplierC2207
values('S08','P.M.Siriwardane','No 32,St.Peters road,Colombo 4');

insert into SupplierC2207
values('S09','S.J.Jayathunga','No 85/1,2th Lane,Colombo 3');

insert into SupplierC2207
values('S10','L.H.Weerasinghe','no 16,Parakum Road,Rathmalana');

insert into SupplierC2207
values('S11','G.A.samarathunga','no 12,primrose rd, Colombo');

insert into SupplierC2207
values('S12','Sahan Wijerathna','No 120,1st lane, Panadura');

insert into SupplierC2207
values('S13','S.A.Mlalasekara','wd rd, Bambalapitiya');

insert into SupplierC2207
values('S14','A.Welagama','No 3,2nd Lane, Kollpity');

insert into SupplierC2207
values('S15','D.Godewithanage','no 55, Dickmon rd, Wallawattha');

----Customer----------------------------------------------------------------------------

insert into CustomerC2207
values('C01','234756897v','Bangamuwage','Thilantha','No 100,Premarathana mv,Madapatha');

insert into CustomerC2207
values('C02','346907864v','Anurudhika','Dilhari','N0 34,Isurupura,Kesbewa');

insert into CustomerC2207
values('C03','098564234v','Wanigasekara','Sajeevi','Subodhi road,Miriswatha');

insert into CustomerC2207
values('C04','198304273v','Perera','Madhuranga','No 78,Temple road,Kaluthara');

insert into CustomerC2207
values('C05','394756291v','Ramanayaka','Sumangi','Cemetery road,Wadhuwa');

insert into CustomerC2207
values('C06','784568824v','Thilanka','Kasun','No 63,Temple Road,Kalutara');

insert into CustomerC2207
values('C07','696916064v','Suranga','Gihan','N0 3/34,Galle Road,Moratuwa');

insert into CustomerC2207
values('C08','778349978v','Weerathunga','Jayantha','No 88,Aththidiya Road,Dehiwala');

insert into CustomerC2207
values('C09','808334273v','Perera','Ruwan','No 5,Senanayaka Road,Kelaniya');

insert into CustomerC2207
values('C10','885267897v','Kirinda','Waruni','No 24, Piyarathana mawatha, Kollpity');

insert into CustomerC2207
values('C11','865463729v','Dissanayake','Dhanushi','N0 45, pirivena rd, Panadura');

insert into CustomerC2207
values('C12','854567234v','Wijerathna','Sandeepani','no 4, samagi rd, Katubadda');

insert into CustomerC2207
values('C13','908304273v','Silva','Madhura','No 56, 1st lane, Kandana');

insert into CustomerC2207
values('C14','914756291v','Rathnayake','Yasith', 'Temple rd, Kaduwela');

insert into CustomerC2207
values('C15','834758991v','Jayathunga','Dilshan','Peris street,Kottawa');



--Type--------------------------------------------------------------------------------

insert into TypeC2207
values('T01','Horror');

insert into TypeC2207
values('T02','Adventure');

insert into TypeC2207
values('T03','Comedy');

insert into TypeC2207
values('T04','Action');

insert into TypeC2207
values('T05','Romance');

insert into TypeC2207
values('T06','Drama');

insert into TypeC2207
values('T07','Science fiction films');

insert into TypeC2207
values('T08','Animated films');

insert into TypeC2207
values('T09','Biography');

insert into TypeC2207
values('T10','Romantic comedy');



--division----------------------------------------------------------------------------

insert into DivisionC2207
values('01','Management','Building01','0112789012');

insert into DivisionC2207
values('02','Customer Service','Building02','0112678901');

insert into DivisionC2207
values('03','Cleaning','Building02','0112567890');

insert into DivisionC2207
values('04','Security','Building02','0112456789');

insert into DivisionC2207
values('05','Human Resources','Building01','0112345678');


--Movie_Item-------------------------------------------------------------------------------


insert into Movie_ItemC2207
values('M004','Drive','English','100 min',50,'09-16-2011','R01','T04');

insert into Movie_ItemC2207
values('M005','Thor','English','115 min',60,'04-06-2011 ','R02','T04');

insert into Movie_ItemC2207
values('M006','Friends with Benefits','English','105 min',50,'07-22-2011','R05','T05');

insert into Movie_ItemC2207
values('M007','A Little Bit of Heaven','English','106 min',50,' 06-10-2011 ','R06','T05');

insert into Movie_ItemC2207
values('M008','Apollo 18','English','86 min ',60,'09-02-2011','R01','T01');

insert into Movie_ItemC2207
values('M009','Priest','English','87 min',70,'04-13-2011','R02','T01');

insert into Movie_ItemC2207
values('M010','X-Men: First Class','English','132 min',60,'05-3-2011','R08','T02');

insert into Movie_ItemC2207
values('M011','Captain America','English','124 min',70,'07-22-2011','R04','T02');

insert into Movie_ItemC2207
values('M012','The Guard','English',' 96 min',75,'07-07-2011','R01','T03');

insert into Movie_ItemC2207
values('M013','Horrible Bosses','English','98 min ',60,'07-08-2011','R02','T03');

insert into Movie_ItemC2207
values('M014','William and Kate','English','101 min ',70,'09/14/2011','R07','T09');

insert into Movie_ItemC2207
values('M015','Angle','Hindi','110 min',50,'08/13/2011','R09','T06');

insert into Movie_ItemC2207
values('M016','Bodyguard','Hindi','122 min',60,'09/03/2011','R04','T01');

insert into Movie_ItemC2207
values('M017','Mausam','Hindi','130 min',55,'09/06/2011','R05','T03');

insert into Movie_ItemC2207
values('M018','Force','Hindi','125 min',70,'09/04/2011','R06','T04');

insert into Movie_ItemC2207
values('M019','Azaan','Hindi','120 min ',70,'09/08/2011','R01','T02');

insert into Movie_ItemC2207
values('M020','Walk to remember','English','120 min',50,'08/22/2011','R03','T08');

insert into Movie_ItemC2207
values('M021','Eclipse','English','130 min',60,'05/8/2011 ','R07','T06');

insert into Movie_ItemC2207
values('M022','Kungfu panda','English','145 min ',50,'06/22/2011','R04','T04');

insert into Movie_ItemC2207
values('M023','Breaking down','English','110 min',60,' 09/10/2011 ','R09','T05');

--Movie_Copy
insert into Movie_CopyC2207
values('M004','01','Unavailable','S02',400,'09/21/2011');

insert into Movie_CopyC2207
values('M004','02','Unavailable','S02',400,'09/21/2011');

insert into Movie_CopyC2207
values('M004','03','Available','S02',400,'09/21/2011');

insert into Movie_CopyC2207
values('M004','04','Available','S03',350,'09/22/2011');

insert into Movie_CopyC2207
values('M004','05','Available','S02',400,'09/21/2011');


insert into Movie_CopyC2207
values('M005','01','Unavailable','S05',500,'05/22/2011');

insert into Movie_CopyC2207
values('M005','02','Available','S05',500,'05/22/2011');

insert into Movie_CopyC2207
values('M005','03','Available','S05',500,'05/22/2011');

insert into Movie_CopyC2207
values('M005','04','Available','S05',500,'05/22/2011');


insert into Movie_CopyC2207
values('M006','01','Unavailable','S01',300,'07/31/2011');

insert into Movie_CopyC2207
values('M006','02','Unavailable','S01',300,'07/31/2011');

insert into Movie_CopyC2207
values('M006','03','Available','S01',300,'07/31/2011');

insert into Movie_CopyC2207
values('M006','04','Available','S01',300,'07/31/2011');


insert into Movie_CopyC2207
values('M007','01','Unavailable','S01',400,'07/14/2011');

insert into Movie_CopyC2207
values('M007','02','Available','S01',400,'07/14/2011');

insert into Movie_CopyC2207
values('M007','03','Available','S01',400,'07/14/2011');


insert into Movie_CopyC2207
values('M008','01','Unavailable','S03',450,'09/23/2011');

insert into Movie_CopyC2207
values('M008','02','Unavailable','S03',450,'09/23/2011');

insert into Movie_CopyC2207
values('M008','03','Available','S03',450,'09/23/2011');

insert into Movie_CopyC2207
values('M008','04','Available','S03',450,'09/23/2011');


insert into Movie_CopyC2207
values('M009','01','Unavailable','S02',500,'05/14/2011');

insert into Movie_CopyC2207
values('M009','02','Unavailable','S02',500,'05/14/2011');

insert into Movie_CopyC2207
values('M009','03','Available','S02',500,'05/14/2011');

insert into Movie_CopyC2207
values('M009','04','Available','S02',500,'05/14/2011');


insert into Movie_CopyC2207
values('M010','01','Available','S04',400,'05/25/2011');

insert into Movie_CopyC2207
values('M010','02','Available','S04',400,'05/25/2011');

insert into Movie_CopyC2207
values('M010','03','Available','S04',400,'05/25/2011');

insert into Movie_CopyC2207
values('M010','04','Available','S04',400,'05/25/2011');


insert into Movie_CopyC2207
values('M011','01','Unavailable','S01',550,'08/01/2011');

insert into Movie_CopyC2207
values('M011','02','Available','S01',550,'08/01/2011');

insert into Movie_CopyC2207
values('M011','03','Available','S01',550,'08/01/2011');

insert into Movie_CopyC2207
values('M011','04','Available','S01',550,'08/01/2011');


insert into Movie_CopyC2207
values('M012','01','Unavailable','S01',600,'08/21/2011');

insert into Movie_CopyC2207
values('M012','02','Unavailable','S01',600,'08/21/2011');

insert into Movie_CopyC2207
values('M012','03','Available','S01',600,'08/21/2011');

insert into Movie_CopyC2207
values('M012','04','Available','S01',600,'08/21/2011');

insert into Movie_CopyC2207
values('M012','05','Available','S01',600,'08/21/2011');


insert into Movie_CopyC2207
values('M013','01','Available','S05',400,'09/01/2011');

insert into Movie_CopyC2207
values('M013','02','Available','S05',400,'09/01/2011');

insert into Movie_CopyC2207
values('M013','03','Available','S05',400,'09/01/2011');

insert into Movie_CopyC2207
values('M013','04','Available','S05',400,'09/01/2011');


insert into Movie_CopyC2207
values('M014','01','Available','S07',500,'05/30/2011');

insert into Movie_CopyC2207
values('M014','02','Available','S07',500,'05/30/2011');

insert into Movie_CopyC2207
values('M014','04','Available','S07',500,'05/30/2011');

insert into Movie_CopyC2207
values('M014','05','Available','S07',500,'05/30/2011');


insert into Movie_CopyC2207
values('M015','01','Unavailable','S07',300,'08/29/2011');

insert into Movie_CopyC2207
values('M015','02','Available','S07',300,'08/29/2011');

insert into Movie_CopyC2207
values('M015','03','Available','S07',300,'08/29/2011');

insert into Movie_CopyC2207
values('M015','04','Available','S07',300,'08/29/2011');


insert into Movie_CopyC2207
values('M016','01','Unavailable','S03',400,'09/15/2011');

insert into Movie_CopyC2207
values('M016','02','Unavailable','S03',400,'09/15/2011');

insert into Movie_CopyC2207
values('M016','03','Available','S03',400,'09/15/2011');

insert into Movie_CopyC2207
values('M016','04','Available','S03',400,'09/15/2011');


insert into Movie_CopyC2207
values('M017','01','Unavailable','S08',350,'09/08/2011');

insert into Movie_CopyC2207
values('M017','02','Unavailable','S08',350,'09/08/2011');

insert into Movie_CopyC2207
values('M017','03','Available','S08',350,'09/08/2011');

insert into Movie_CopyC2207
values('M017','04','Available','S08',350,'09/08/2011');


insert into Movie_CopyC2207
values('M018','01','Available','S04',500,'09/10/2011');

insert into Movie_CopyC2207
values('M018','02','Available','S04',500,'09/10/2011');

insert into Movie_CopyC2207
values('M018','03','Available','S04',500,'09/10/2011');

insert into Movie_CopyC2207
values('M018','04','Available','S04',500,'09/10/2011');


insert into Movie_CopyC2207
values('M019','01','Unavailable','S02',500,'08/14/2011');

insert into Movie_CopyC2207
values('M019','02','Unavailable','S02',500,'08/14/2011');

insert into Movie_CopyC2207
values('M019','03','Available','S02',500,'08/14/2011');

insert into Movie_CopyC2207
values('M019','04','Available','S02',500,'08/14/2011');


insert into Movie_CopyC2207
values('M020','01','Available','S05',300,'08/26/2011');

insert into Movie_CopyC2207
values('M020','02','Available','S05',300,'08/26/2011');

insert into Movie_CopyC2207
values('M020','03','Available','S05',300,'08/26/2011');

insert into Movie_CopyC2207
values('M020','04','Available','S05',300,'08/26/2011');


insert into Movie_CopyC2207
values('M021','01','Unavailable','S09',400,'05/22/2011');

insert into Movie_CopyC2207
values('M021','02','Unavailable','S09',400,'05/22/2011');

insert into Movie_CopyC2207
values('M021','03','Available','S09',400,'05/22/2011');

insert into Movie_CopyC2207
values('M021','04','Available','S09',400,'05/22/2011');


insert into Movie_CopyC2207
values('M022','01','Unavailable','S08',350,'07/08/2011');

insert into Movie_CopyC2207
values('M022','02','Available','S08',350,'07/08/2011');

insert into Movie_CopyC2207
values('M022','03','Available','S08',350,'07/08/2011');

insert into Movie_CopyC2207
values('M022','04','Available','S08',350,'07/08/2011');


insert into Movie_CopyC2207
values('M023','01','Unavailable','S03',450,'07/26/2011');

insert into Movie_CopyC2207
values('M023','02','Unavailable','S03',450,'07/26/2011');

insert into Movie_CopyC2207
values('M023','03','Available','S03',450,'07/26/2011');

insert into Movie_CopyC2207
values('M023','04','Available','S03',450,'07/26/2011');


--employee


insert into employeeC2207
values('E001','Isuru','Samaravira','N0 17,Pitagampala road,mirihana,Colombo 2','05/20/2010','01','273093721v');

insert into employeeC2207
values('E002','Sampath','WiJesundhara','No 11,siriniwasa road,kalawana,Rathnapura','01/23/2011','02','028364532v');

insert into employeeC2207
values('E003','Udari','De silva','No 321,beach cross road,Hikaduwa,Galle','04/14/2009','04','568230432v');

insert into EmployeeC2207
values('E004','Thilini','Perera','N0 26,Samagi Mawatha,Panadura','05/05/2011','04','853435721v');

insert into EmployeeC2207
values('E005','Sanka','Amarasinghe','No 2/52,Temple road,kalutara north','03/10/2010','05','788366732v');

insert into EmployeeC2207
values('E006','Senaka','Rodrigo','No 176,D.S.Senanayake Street,Nugegoda','03/25/2009','02','728909432v');

insert into employeeC2207
values('E007','Chathuri','Gunathilake','N0 23/2, sena mawatha, Boralla','06/05/2009','02','823093721v');

insert into employeeC2207
values('E008','Senarath','Wirasinghe','no 34, waligalla, Gampola','02/12/2010','01','858364532v');

insert into employeeC2207
values('E009','Udara','Senevirathna','No 1, samagi mawatha, Kegalle','5/04/2011','05','888230432v');

insert into employeeC2207
values('E010','Asitha','Samaranayake','No 67/B, Udugama rd, Battaramulla','5/04/2011','02','888230432v');

insert into employeeC2207
values('E011','Mahanama','Rathnayake','No 24, Saman Mawatha, Mortuwa','5/04/2011','03','878236778v');

insert into employeeC2207
values('E012','Sarath','Gunapala','No 45/3, 2nd Lane, Park Road, Dehiwala','5/04/2011','03','734893432v');


--C_Borrow_and_Return


insert into C_Borrow_and_ReturnC2207
values('M006','01','C04',50,'09/21/2011',null,00);

insert into C_Borrow_and_ReturnC2207
values('M007','01','C02',50,'09/16/2011',null,00);

insert into C_Borrow_and_ReturnC2207
values('M013','01','C01',60,'04/20/2011','04/22/2011',00);

insert into C_Borrow_and_ReturnC2207
values('M010','01','C10',60,'06/03/2011','06/10/2011',00);

insert into C_Borrow_and_ReturnC2207
values('M011','01','C10',70,'09/24/2011',null,00);

insert into C_Borrow_and_ReturnC2207
values('M013','01','C15',60,'09/21/2011','09/25/2011',00);

insert into C_Borrow_and_ReturnC2207
values('M008','02','C03',60,'09/23/2011',null,00);

insert into C_Borrow_and_ReturnC2207
values('M010','01','C12',60,'08/03/2011','08/15/2011',50);

insert into C_Borrow_and_ReturnC2207
values('M013','01','C04',60,'04/15/2011','04/22/2011',00);


--E_Borrow_and_Return


insert into E_Borrow_and_ReturnC2207
values('M007','02','E003',10,40,'08/19/2011','08/26/2011');

insert into E_Borrow_and_ReturnC2207
values('M011','03','E001',15,55,'08/22/2011','08/25/2011');

insert into E_Borrow_and_ReturnC2207
values('M009','02','E002',15,55,'09/24/2011',null);

insert into E_Borrow_and_ReturnC2207
values('M014','01','E005',15,55,'07/10/2011','07/15/2011');

insert into E_Borrow_and_ReturnC2207
values('M015','01','E007',10,40,'09/22/2011',null);

insert into E_Borrow_and_ReturnC2207
values('M016','02','E009',10,50,'09/23/2011',null);

insert into E_Borrow_and_ReturnC2207
values('M006','02','E003',10,40,'09/20/2011','09/25/2011');

insert into E_Borrow_and_ReturnC2207
values('M019','02','E001',15,55,'09/17/2011',null);

insert into E_Borrow_and_ReturnC2207
values('M023','01','E002',10,50,'09/19/2011',null);


--Customer-pone_no


insert into Customer_Phone_NoC2207
values('C01','0712384032');

insert into Customer_Phone_NoC2207
values('C01','0713482741');

insert into Customer_Phone_NoC2207
values('C02','0772312832');

insert into Customer_Phone_NoC2207
values('C03','0712342389');

insert into Customer_Phone_NoC2207
values('C03','0784590832');

insert into Customer_Phone_NoC2207
values('C04','0784230832');

insert into Customer_Phone_NoC2207
values('C05','0714590432');

insert into Customer_Phone_NoC2207
values('C05','0784590856');

insert into Customer_Phone_NoC2207
values('C05','0720456382');

insert into Customer_Phone_NoC2207
values('C06','0716678732');

insert into Customer_Phone_NoC2207
values('C06','0714898856');

insert into Customer_Phone_NoC2207
values('C07','0779877382');

insert into Customer_Phone_NoC2207
values('C07','0723482741');

insert into Customer_Phone_NoC2207
values('C07','0772390832');

insert into Customer_Phone_NoC2207
values('C08','0782342389');

insert into Customer_Phone_NoC2207
values('C08','0713450832');

insert into Customer_Phone_NoC2207
values('C09','0774008832');

insert into Customer_Phone_NoC2207
values('C10','0753420432');

insert into Customer_phone_noC2207
values('C10','0713456728');

insert into Customer_phone_noC2207
values('C11','0756737399');

insert into Customer_phone_noC2207
values('C11','0724536784');

insert into Customer_phone_noC2207
values('C12','0715643091');

insert into Customer_phone_noC2207
values('C12','0718739758');

insert into Customer_phone_noC2207
values('C13','0711098236');

insert into Customer_phone_noC2207
values('C13','0773769104');

insert into Customer_phone_noC2207
values('C14','0783678103');

insert into Customer_phone_noC2207
values('C15','0772891092');


--Customer_Email


insert into Customer_EmailC2207
values('C01','thilantha@yahoo.com');

insert into Customer_EmailC2207
values('C01','yasitha2k9@gmail.com');

insert into Customer_EmailC2207
values('C02','dilhari@gmail.com');

insert into Customer_EmailC2207
values('C03','sajivi@gmail.com');

insert into Customer_EmailC2207
values('C04','maduranga_sliit@yahoo.com');

insert into Customer_EmailC2207
values('C05','sumangi_2009@gmail.com');

insert into Customer_EmailC2207
values('C05','sumangi_piumika@yahoo.com');

insert into Customer_EmailC2207
values('C06','wmkthilanka@yahoo.com');

insert into Customer_EmailC2207
values('C07','dazchanake@gmail.com');

insert into Customer_EmailC2207
values('C07','surangame@yahoo.com');

insert into Customer_EmailC2207
values('C08','J_indikaf@gmail.com');

insert into Customer_EmailC2207
values('C09','yruwan@gmail.com');

insert into Customer_EmailC2207
values('C10','dilshanme@ymail.com');

insert into Customer_EmailC2207
values('C10','dilzJay@yahoo.com');

insert into Customer_EmailC2207
values('C10','lakmini@yahoo.com');

insert into Customer_EmailC2207
values('C11','gayani@gmail.com');

insert into Customer_EmailC2207
values('C12','chathuri@gmail.com');

insert into Customer_EmailC2207
values('C13','dhanu_90@yahoo.com');

insert into Customer_EmailC2207
values('C14','erandi_88@gmail.com');

insert into Customer_EmailC2207
values('C15','vidura_jaya@yahoo.com');

insert into Customer_EmailC2207
values('C15','madhavirandi@gmail.com');


--Supplier_phone_no

insert into Supplier_Phone_NoC2207
values('S01','0712378945');

insert into Supplier_Phone_NoC2207
values('S02','0724535675');

insert into Supplier_Phone_NoC2207
values('S03','0783412342');

insert into Supplier_Phone_NoC2207
values('S04','0715687890');

insert into Supplier_Phone_NoC2207
values('S05','0776756453');

insert into Supplier_Phone_NoC2207
values('S05','0712345732');

insert into Supplier_Phone_NoC2207
values('S06','0112678945');

insert into Supplier_Phone_NoC2207
values('S06','0774512335');

insert into Supplier_Phone_NoC2207
values('S07','0112978342');

insert into Supplier_Phone_NoC2207
values('S08','0112287890');

insert into Supplier_Phone_NoC2207
values('S09','0113583455');

insert into Supplier_Phone_NoC2207
values('S10','0712897832');

insert into supplier_phone_noC2207
values('S10','0772891036');

insert into supplier_phone_noC2207
values('S11','0716385674');

insert into supplier_phone_noC2207
values('S12','0712139501');

insert into supplier_phone_noC2207
values('S13','0753201750');

insert into supplier_phone_noC2207
values('S14','0772016783');

insert into supplier_phone_noC2207
values('S15','0720123418');

--supplier_Email

insert into Supplier_EmailC2207
values('S01','pererarox@gmail.com');

insert into supplier_EmailC2207
values('S02','ravin_movie@yahoo.com');

insert into supplier_EmailC2207
values('S03','jayarathna@gmail.com');

insert into supplier_EmailC2207
values('S04','akila2k8@yahoo.com');

insert into supplier_EmailC2207
values('S04','akila2k8@gmail.com');

insert into supplier_EmailC2207
values('S05','kirinda_lakmini@yahoo.com');

insert into Supplier_EmailC2207
values('S06','SS_Meegoda@gmail.com');

insert into Supplier_EmailC2207
values('S07','kaviPerera@hotmail.com');

insert into Supplier_EmailC2207
values('S08','M_Siriwardane@gmail.com');

insert into Supplier_EmailC2207
values('S09','pasinduJaya@hotmail.com');

insert into Supplier_EmailC2207
values('S10','sanjaya.nitro@yahoo.com');

insert into supplier_EmailC2207
values('S10','sahan_max@gmail.com');

insert into supplier_EmailC2207
values('S11','romesh_movie@yahoo.com');

insert into supplier_EmailC2207
values('S12','jayasinghe@gmail.com');

insert into supplier_EmailC2207
values('S13','sathsara_21@yahoo.com');

insert into supplier_EmailC2207
values('S14','deva_2011@yahoo.com');

insert into supplier_EmailC2207
values('S15','ashan_85@gmail.com');


--Employee_Phone-no

insert into Employee_Phone_noC2207
values('E001','0710485346');

insert into Employee_Phone_noC2207
values('E001','0773478904');

insert into Employee_Phone_noC2207
values('E002','0784567382');

insert into Employee_Phone_noC2207
values('E002','0785690384');

insert into Employee_Phone_noC2207
values('E003','0770384956');

insert into Employee_Phone_noC2207
values('E003','0713461234');

insert into Employee_Phone_NoC2207
values('E004','0772234546');

insert into Employee_Phone_NoC2207
values('E004','0382278904');

insert into Employee_Phone_NoC2207
values('E005','0715786789');

insert into Employee_Phone_NoC2207
values('E005','0342235328');

insert into Employee_Phone_NoC2207
values('E006','0779898765');

insert into Employee_Phone_NoC2207
values('E006','0716565874');

insert into Employee_Phone_noC2207
values('E006','0778491046');

insert into Employee_Phone_noC2207
values('E007','0771029384');

insert into Employee_Phone_noC2207
values('E007','0750192938');

insert into Employee_Phone_noC2207
values('E008','0781582307');

insert into Employee_Phone_noC2207
values('E008','0775875765');

insert into Employee_Phone_noC2207
values('E009','0713546575');


--Employee_Email

insert into Employee_EmailC2207
values('E001','Samaravira@yahoo.com');

insert into Employee_EmailC2207
values('E001','isuru_samaravira@gmail.com');

insert into Employee_EmailC2207
values('E002','Wigesundhara@yahoo.com');

insert into Employee_EmailC2207
values('E002','sampath2k9@gmail.com');

insert into Employee_EmailC2207
values('E003','desilva@gmail.com');

insert into Employee_EmailC2207
values('E003','Udari@yahoo.com');

insert into Employee_EmailC2207
values('E004','Thilini@yahoo.com');

insert into Employee_EmailC2207
values('E004','dksljets@gmail.com');

insert into Employee_EmailC2207
values('E005','Sanka@yahoo.com');

insert into Employee_EmailC2207
values('E005','calsav765@ymail.com.com');

insert into Employee_EmailC2207
values('E006','Senaka@gmail.com');

insert into Employee_EmailC2207
values('E006','ymjkb89@gmail.com');

insert into Employee_EmailC2207
values('E007','priyanwada@yahoo.com');

insert into Employee_EmailC2207
values('E008','jaya_randima@gmail.com');

insert into Employee_EmailC2207
values('E008','senarathnna@yahoo.com');

insert into Employee_EmailC2207
values('E008','sandani@gmail.com');

insert into Employee_EmailC2207
values('E009','uthpala_88@gmail.com');

insert into Employee_EmailC2207
values('E009','mekhala@yahoo.com');